CREATE TABLE carconsump ( – Change table_name to the table name you want. year varchar2(4000), manufacturer varchar2(4000), model varchar2(4000), engine varchar2(4000), transmission varchar2(4000), transmission_type varchar2(4000), fuel_type varchar2(4000), X varchar2(4000), X_1 varchar2(4000), X_2 varchar2(4000), X_3 varchar2(4000), X_4 varchar2(4000), X_5 varchar2(4000), X_6 varchar2(4000), X_7 varchar2(4000), X_8 varchar2(4000), X_9 varchar2(4000), euro_standard number(38,4), engine_capacity number(38,4), urban_metric number(38,4), extra_urban_metric number(38,4), combined_metric number(38,4), urban_imperial number(38,4), extra_urban_imperial number(38,4), combined_imperial number(38,4), noise_level number(38,4), co2 number(38,4), co_emissions number(38,4), fuel_cost_6000_miles number(38,4) );
##When Tableau creates a data extract, it first defines the structure for the TDE and creates separate files for each column in the underlying source.To complete the creation of a TDE, individual column files are combined with metadata to form a memory-mapped file. Because a TDE is a memory-mapped file, when Tableau requests data from a TDE, the data is loaded directly into memory by the operating system. Tableau doesn’t have to open, process or decompress the TDE to start using it. If necessary, the operating system continues to move data in and out of RAM to insure that all of the requested data is made available to Tableau. This is a key point - it means that Tableau can query data that is bigger than the available RAM on a machine!
The main fuel type used by this group of cars with price rage $ 30,000 - $ 150,000 are Diesel and Petrol. If using Deisel, Mercedez-Benz, Audi, BMW, Jaguar and other except Land Rover has mean carbon emissions between 150 - 200 grammes per kilometre (g/km). If using Petrol, Mercedez-Benz, Audi, BMW have average near 200 grammes per kilometre (g/km). The worst performing manufacturer is Land Rover which has mean Co2 emissions up to 350 grammes per kilometre (g/km).
##3. Describe Trend Model
Urban-Imperial here defines fuel consumption in miles per gallon (mpg). The scatterplot hints a logarithmic model type with model formula: Fuel Type*( log(Urban Imperial) + intercept ). It shows that the more miles sustained by a gallon, the fewer Co2 emissions by this car. That is the more efficient the engine or the fuel, the less Co2 pruduced. Get #97 for your car!
Upper 70s (dB (A)) are annoyingly loud to some people. So next I compare the Average of the all the Noise made by these engines to the threshold 70s (dB (A)).
Clearly the Average noise made by all these years from 2000 to 2013 have surpassed the standards of human comfort.
##4. Drag Year to Pages Shelf and step through each year from 2000 to 2004.